package com.cscec.omega.dao;

import com.cscec.omega.entity.APIEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface ApiDao extends JpaRepository<APIEntity, Integer> {

    List<APIEntity> findAllByStatus(Integer status);

//    @Query(value = "select api.*, pro.name as projectName from tbl_api as api left join tbl_project as pro on pro.id = api.project_id", nativeQuery = true)
//    List<APIEntity> findAll();
}
